﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

using UTIL;
using System.Data;
using System.Data.SqlClient;

namespace transportsystem.DAO
{
    public class ChucVuDAO
    {
        public static DataTable layChucVuTheoMa(int macv)
        {
            SqlDataAccessHelper.ConnectSQLServer();
            string procName = "sp_LayChucVuTheoMa";
            SqlParameter[] sp = new SqlParameter[1];
            sp[0] = new SqlParameter("@macv", macv);
            DataSet ds = SqlDataAccessHelper.LoadDataWithParameter(procName, sp);
            if (ds != null)
                return ds.Tables[0];
            return null;
        }
    }
}
